Syllabus
Data Analyst Curriculum
- VLOOKUP, HLOOKUP, INDEX, MATCH
- Date, Text & Statistical Functions
- Sorting, Filtering, Data Validation
- Pivot Tables & Pivot Charts
- Dashboards & Dynamic Charts
- Data Import/Export (CSV, PDF)
- Macros & Automation
- Data Cleaning & Preparation
- DQL, DML, DDL, DCL, TCL Commands
- SELECT, WHERE, GROUP BY, HAVING
- Joins (Inner, Left, Right, Full)
- Subqueries & Window Functions
- Aggregate & Analytical Functions
- Variables, Data Types, Lists, Dictionaries
- Loops, Conditions, Functions
- Pandas (Data Cleaning & Analysis)
- Matplotlib (Data Visualization)
- Working with CSV, Excel, JSON
- Power BI Introduction & UI
- Data Connections (Excel, SQL, Cloud)
- Charts: Bar, Line, Pie, Scatter
- Dashboard Design & Formatting
- Data Modeling & Relationships
- Power Query (Data Cleaning)
- DAX Basics
- Descriptive Statistics
- Probability Basics
- Distributions
- Hypothesis Testing
- JIRA Tool
- Real-world Projects (HR, Banking, Ecommerce)
- Resume & Portfolio Building
- LinkedIn & Naukri Profile Setup
- Interview Preparation
- Soft Skills Training
Every Course Includes
- 01 Sunday Mock Interview Prep
- 02 Comprehensive Study Notes
- 03 Real-Time Project Explanation
- 04 HR Strategy Session
- 05 Naukri Profile Optimization
- 06 LinkedIn Mastery Session
- 07 Professional Resume Building
- 08 Daily One Hour Live Class
- 09 100% Online Classes
